1 -- phpMyAdmin SQL Dump
2 -- version 4.8.3
3 -- https://www.phpmyadmin.net/
4 --
5 -- Host: 127.0.0.1
6 -- Generation Time: Jun 24, 2019 at 06:41 AM
7 -- Server version: 10.1.37-MariaDB
8 -- PHP Version: 7.2.12
9
10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11 SET AUTOCOMMIT = 0;
12 START TRANSACTION;
13 SET time_zone = "+00:00";
14
15
16 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19 /*!40101 SET NAMES utf8mb4 */;
20
21 --
22 -- Database: `dblms`
23 --
24
25 -- --------------------------------------------------------
26
27 --
28 -- Table structure for table `category`
29 --
30
31 CREATE TABLE `category` (
32 `id` int(11) UNSIGNED NOT NULL,
33 `code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
34 `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
35 `parent` int(11) DEFAULT '0',
36 `slug` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
37 `date_added` int(11) DEFAULT NULL,
38 `last_modified` int(11) DEFAULT NULL,
39 `font_awesome_class` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
40 `thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL
41 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
42
43 -- --------------------------------------------------------
44
45 --
46 -- Table structure for table `ci_sessions`
47 --
48
49 CREATE TABLE `ci_sessions` (
50 `id` varchar(40) COLLATE utf8_unicode_ci NOT NULL,
51 `ip_address` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
52 `timestamp` int(10) UNSIGNED NOT NULL DEFAULT '0',
53 `data` blob NOT NULL
54 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
55
56 --
57 -- Dumping data for table `ci_sessions`
58 --
59
60 INSERT INTO `ci_sessions` (`id`, `ip_address`, `timestamp`, `data`) VALUES
61 ('u7jn4j62nnbfstbc61ei1vcs7arisqdn', '::1', 1561169011, 0x5f5f63695f6c6173745f726567656e65726174657c693a313536313136383934313b636172745f6974656d737c613a303a7b7d757365725f69647c733a313a2231223b726f6c655f69647c733a313a2231223b726f6c657c733a353a2241646d696e223b6e616d657c733a31313a2261646d696e2061646d696e223b61646d696e5f6c6f67696e7c733a313a2231223b),
62 ('dpb2fi40qktdgagl2fgvv3nhce4dfun4', '::1', 1561300719, 0x5f5f63695f6c6173745f726567656e65726174657c693a313536313330303731393b636172745f6974656d737c613a303a7b7d),
63 ('2k91kfslkj6l19jl9rnc2ivrnb8pna7r', '::1', 1561351070, 0x5f5f63695f6c6173745f726567656e65726174657c693a313536313335313032363b636172745f6974656d737c613a303a7b7d757365725f69647c733a313a2231223b726f6c655f69647c733a313a2231223b726f6c657c733a353a2241646d696e223b6e616d657c733a31313a2261646d696e2061646d696e223b61646d696e5f6c6f67696e7c733a313a2231223b);
64
65 -- --------------------------------------------------------
66
67 --
68 -- Table structure for table `comment`
69 --
70
71 CREATE TABLE `comment` (
72 `id` int(11) UNSIGNED NOT NULL,
73 `body` longtext COLLATE utf8_unicode_ci,
74 `user_id` int(11) DEFAULT NULL,
75 `commentable_id` int(11) DEFAULT NULL,
76 `commentable_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
77 `date_added` int(11) DEFAULT NULL,
78 `last_modified` int(11) DEFAULT NULL
79 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
80
81 -- --------------------------------------------------------
82
83 --
84 -- Table structure for table `course`
85 --
86
87 CREATE TABLE `course` (
88 `id` int(11) UNSIGNED NOT NULL,
89 `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
90 `short_description` longtext COLLATE utf8_unicode_ci,
91 `description` longtext COLLATE utf8_unicode_ci,
92 `outcomes` longtext COLLATE utf8_unicode_ci,
93 `language` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
94 `category_id` int(11) DEFAULT NULL,
95 `sub_category_id` int(11) DEFAULT NULL,
96 `section` longtext COLLATE utf8_unicode_ci,
97 `requirements` longtext COLLATE utf8_unicode_ci,
98 `price` double DEFAULT NULL,
99 `discount_flag` int(11) DEFAULT '0',
100 `discounted_price` int(11) DEFAULT NULL,
101 `level` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
102 `user_id` int(11) DEFAULT NULL,
103 `thumbnail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
104 `video_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
105 `date_added` int(11) DEFAULT NULL,
106 `last_modified` int(11) DEFAULT NULL,
107 `visibility` int(11) DEFAULT NULL,
108 `is_top_course` int(11) DEFAULT '0',
109 `is_admin` int(11) DEFAULT NULL,
110 `status` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
111 `course_overview_provider` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
112 `meta_keywords` longtext COLLATE utf8_unicode_ci,
113 `meta_description` longtext COLLATE utf8_unicode_ci,
114 `is_free_course` int(11) DEFAULT NULL
115 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
116
117 -- --------------------------------------------------------
118
119 --
120 -- Table structure for table `currency`
121 --
122
123 CREATE TABLE `currency` (
124 `id` int(11) NOT NULL,
125 `name` varchar(255) DEFAULT NULL,
126 `code` varchar(255) DEFAULT NULL,
127 `symbol` varchar(255) DEFAULT NULL,
128 `paypal_supported` int(11) DEFAULT NULL,
129 `stripe_supported` int(11) DEFAULT NULL
130 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
131
132 --
133 -- Dumping data for table `currency`
134 --
135
136 INSERT INTO `currency` (`id`, `name`, `code`, `symbol`, `paypal_supported`, `stripe_supported`) VALUES
137 (1, 'Leke', 'ALL', 'Lek', 0, 1),
138 (2, 'Dollars', 'USD', '$', 1, 1),
139 (3, 'Afghanis', 'AFN', '؋', 0, 1),
140 (4, 'Pesos', 'ARS', '$', 0, 1),
141 (5, 'Guilders', 'AWG', 'ƒ', 0, 1),
142 (6, 'Dollars', 'AUD', '$', 1, 1),
143 (7, 'New Manats', 'AZN', 'ман', 0, 1),
144 (8, 'Dollars', 'BSD', '$', 0, 1),
145 (9, 'Dollars', 'BBD', '$', 0, 1),
146 (10, 'Rubles', 'BYR', 'p.', 0, 0),
147 (11, 'Euro', 'EUR', '€', 1, 1),
148 (12, 'Dollars', 'BZD', 'BZ$', 0, 1),
149 (13, 'Dollars', 'BMD', '$', 0, 1),
150 (14, 'Bolivianos', 'BOB', '$b', 0, 1),
151 (15, 'Convertible Marka', 'BAM', 'KM', 0, 1),
152 (16, 'Pula', 'BWP', 'P', 0, 1),
153 (17, 'Leva', 'BGN', 'лв', 0, 1),
154 (18, 'Reais', 'BRL', 'R$', 1, 1),
155 (19, 'Pounds', 'GBP', '£', 1, 1),
156 (20, 'Dollars', 'BND', '$', 0, 1),
157 (21, 'Riels', 'KHR', '៛', 0, 1),
158 (22, 'Dollars', 'CAD', '$', 1, 1),
159 (23, 'Dollars', 'KYD', '$', 0, 1),
160 (24, 'Pesos', 'CLP', '$', 0, 1),
161 (25, 'Yuan Renminbi', 'CNY', '¥', 0, 1),
162 (26, 'Pesos', 'COP', '$', 0, 1),
163 (27, 'Colón', 'CRC', '₡', 0, 1),
164 (28, 'Kuna', 'HRK', 'kn', 0, 1),
165 (29, 'Pesos', 'CUP', '₱', 0, 0),
166 (30, 'Koruny', 'CZK', 'Kč', 1, 1),
167 (31, 'Kroner', 'DKK', 'kr', 1, 1),
168 (32, 'Pesos', 'DOP ', 'RD$', 0, 1),
169 (33, 'Dollars', 'XCD', '$', 0, 1),
170 (34, 'Pounds', 'EGP', '£', 0, 1),
171 (35, 'Colones', 'SVC', '$', 0, 0),
172 (36, 'Pounds', 'FKP', '£', 0, 1),
173 (37, 'Dollars', 'FJD', '$', 0, 1),
174 (38, 'Cedis', 'GHC', '¢', 0, 0),
175 (39, 'Pounds', 'GIP', '£', 0, 1),
176 (40, 'Quetzales', 'GTQ', 'Q', 0, 1),
177 (41, 'Pounds', 'GGP', '£', 0, 0),
178 (42, 'Dollars', 'GYD', '$', 0, 1),
179 (43, 'Lempiras', 'HNL', 'L', 0, 1),
180 (44, 'Dollars', 'HKD', '$', 1, 1),
181 (45, 'Forint', 'HUF', 'Ft', 1, 1),
182 (46, 'Kronur', 'ISK', 'kr', 0, 1),
183 (47, 'Rupees', 'INR', 'Rp', 0, 1),
184 (48, 'Rupiahs', 'IDR', 'Rp', 0, 1),
185 (49, 'Rials', 'IRR', '﷼', 0, 0),
186 (50, 'Pounds', 'IMP', '£', 0, 0),
187 (51, 'New Shekels', 'ILS', '₪', 1, 1),
188 (52, 'Dollars', 'JMD', 'J$', 0, 1),
189 (53, 'Yen', 'JPY', '¥', 1, 1),
190 (54, 'Pounds', 'JEP', '£', 0, 0),
191 (55, 'Tenge', 'KZT', 'лв', 0, 1),
192 (56, 'Won', 'KPW', '₩', 0, 0),
193 (57, 'Won', 'KRW', '₩', 0, 1),
194 (58, 'Soms', 'KGS', 'лв', 0, 1),
195 (59, 'Kips', 'LAK', '₭', 0, 1),
196 (60, 'Lati', 'LVL', 'Ls', 0, 0),
197 (61, 'Pounds', 'LBP', '£', 0, 1),
198 (62, 'Dollars', 'LRD', '$', 0, 1),
199 (63, 'Switzerland Francs', 'CHF', 'CHF', 1, 1),
200 (64, 'Litai', 'LTL', 'Lt', 0, 0),
201 (65, 'Denars', 'MKD', 'ден', 0, 1),
202 (66, 'Ringgits', 'MYR', 'RM', 1, 1),
203 (67, 'Rupees', 'MUR', '₨', 0, 1),
204 (68, 'Pesos', 'MXN', '$', 1, 1),
205 (69, 'Tugriks', 'MNT', '₮', 0, 1),
206 (70, 'Meticais', 'MZN', 'MT', 0, 1),
207 (71, 'Dollars', 'NAD', '$', 0, 1),
208 (72, 'Rupees', 'NPR', '₨', 0, 1),
209 (73, 'Guilders', 'ANG', 'ƒ', 0, 1),
210 (74, 'Dollars', 'NZD', '$', 1, 1),
211 (75, 'Cordobas', 'NIO', 'C$', 0, 1),
212 (76, 'Nairas', 'NGN', '₦', 0, 1),
213 (77, 'Krone', 'NOK', 'kr', 1, 1),
214 (78, 'Rials', 'OMR', '﷼', 0, 0),
215 (79, 'Rupees', 'PKR', '₨', 0, 1),
216 (80, 'Balboa', 'PAB', 'B/.', 0, 1),
217 (81, 'Guarani', 'PYG', 'Gs', 0, 1),
218 (82, 'Nuevos Soles', 'PEN', 'S/.', 0, 1),
219 (83, 'Pesos', 'PHP', 'Php', 1, 1),
220 (84, 'Zlotych', 'PLN', 'zł', 1, 1),
221 (85, 'Rials', 'QAR', '﷼', 0, 1),
222 (86, 'New Lei', 'RON', 'lei', 0, 1),
223 (87, 'Rubles', 'RUB', 'руб', 0, 1),
224 (88, 'Pounds', 'SHP', '£', 0, 1),
225 (89, 'Riyals', 'SAR', '﷼', 0, 1),
226 (90, 'Dinars', 'RSD', 'Дин.', 0, 1),
227 (91, 'Rupees', 'SCR', '₨', 0, 1),
228 (92, 'Dollars', 'SGD', '$', 1, 1),
229 (93, 'Dollars', 'SBD', '$', 0, 1),
230 (94, 'Shillings', 'SOS', 'S', 0, 1),
231 (95, 'Rand', 'ZAR', 'R', 0, 1),
232 (96, 'Rupees', 'LKR', '₨', 0, 1),
233 (97, 'Kronor', 'SEK', 'kr', 1, 1),
234 (98, 'Dollars', 'SRD', '$', 0, 1),
235 (99, 'Pounds', 'SYP', '£', 0, 0),
236 (100, 'New Dollars', 'TWD', 'NT$', 1, 1),
237 (101, 'Baht', 'THB', '฿', 1, 1),
238 (102, 'Dollars', 'TTD', 'TT$', 0, 1),
239 (103, 'Lira', 'TRY', 'TL', 0, 1),
240 (104, 'Liras', 'TRL', '£', 0, 0),
241 (105, 'Dollars', 'TVD', '$', 0, 0),
242 (106, 'Hryvnia', 'UAH', '₴', 0, 1),
243 (107, 'Pesos', 'UYU', '$U', 0, 1),
244 (108, 'Sums', 'UZS', 'лв', 0, 1),
245 (109, 'Bolivares Fuertes', 'VEF', 'Bs', 0, 0),
246 (110, 'Dong', 'VND', '₫', 0, 1),
247 (111, 'Rials', 'YER', '﷼', 0, 1),
248 (112, 'Zimbabwe Dollars', 'ZWD', 'Z$', 0, 0);
249
250 -- --------------------------------------------------------
251
252 --
253 -- Table structure for table `enrol`
254 --
255
256 CREATE TABLE `enrol` (
257 `id` int(11) UNSIGNED NOT NULL,
258 `user_id` int(11) DEFAULT NULL,
259 `course_id` int(11) DEFAULT NULL,
260 `date_added` int(11) DEFAULT NULL,
261 `last_modified` int(11) DEFAULT NULL
262 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
263
264 -- --------------------------------------------------------
265
266 --
267 -- Table structure for table `frontend_settings`
268 --
269
270 CREATE TABLE `frontend_settings` (
271 `id` int(11) UNSIGNED NOT NULL,
272 `key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
273 `value` longtext COLLATE utf8_unicode_ci
274 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
275
276 --
277 -- Dumping data for table `frontend_settings`
278 --
279
280 INSERT INTO `frontend_settings` (`id`, `key`, `value`) VALUES
281 (1, 'banner_title', 'Learn on your schedule'),
282 (2, 'banner_sub_title', 'Study any topic, anytime. Explore thousands of courses for the lowest price ever!'),
283 (4, 'about_us', '<p></p><h2>This is about us</h2><p><span xss=\"removed\" xss=removed>Welcome to Academy. It will help you to learn in a new ways</span></p>'),
284 (10, 'terms_and_condition', '<h2>Terms and Condition</h2>This is the Terms and condition page for your companys'),
285 (11, 'privacy_policy', '<h2>Privacy Policy</h2>This is the Privacy Policy page for your companys'),
286 (13, 'theme', 'default');
287
288 -- --------------------------------------------------------
289
290 --
291 -- Table structure for table `language`
292 --
293
294 CREATE TABLE `language` (
295 `phrase_id` int(11) NOT NULL,
296 `phrase` longtext COLLATE utf8_unicode_ci,
297 `english` longtext COLLATE utf8_unicode_ci,
298 `Bengali` longtext COLLATE utf8_unicode_ci
299 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
300
301 --
302 -- Dumping data for table `language`
303 --
304
305 INSERT INTO `language` (`phrase_id`, `phrase`, `english`, `Bengali`) VALUES
306 (1, 'manage_profile', NULL, NULL),
307 (140, 'category_code', NULL, NULL),
308 (3, 'dashboard', NULL, NULL),
309 (4, 'categories', NULL, NULL),
310 (5, 'courses', NULL, NULL),
311 (6, 'students', NULL, NULL),
312 (7, 'enroll_history', NULL, NULL),
313 (8, 'message', NULL, NULL),
314 (9, 'settings', NULL, NULL),
315 (10, 'system_settings', NULL, NULL),
316 (11, 'frontend_settings', NULL, NULL),
317 (12, 'payment_settings', NULL, NULL),
318 (13, 'manage_language', NULL, NULL),
319 (14, 'edit_profile', NULL, NULL),
320 (15, 'log_out', NULL, NULL),
321 (16, 'first_name', NULL, NULL),
322 (17, 'last_name', NULL, NULL),
323 (18, 'email', NULL, NULL),
324 (19, 'facebook_link', NULL, NULL),
325 (20, 'twitter_link', NULL, NULL),
326 (21, 'linkedin_link', NULL, NULL),
327 (22, 'a_short_title_about_yourself', NULL, NULL),
328 (23, 'biography', NULL, NULL),
329 (24, 'photo', NULL, NULL),
330 (25, 'select_image', NULL, NULL),
331 (26, 'change', NULL, NULL),
332 (27, 'remove', NULL, NULL),
333 (28, 'update_profile', NULL, NULL),
334 (29, 'change_password', NULL, NULL),
335 (30, 'current_password', NULL, NULL),
336 (31, 'new_password', NULL, NULL),
337 (32, 'confirm_new_password', NULL, NULL),
338 (33, 'delete', NULL, NULL),
339 (34, 'cancel', NULL, NULL),
340 (35, 'are_you_sure_to_update_this_information', NULL, NULL),
341 (36, 'yes', NULL, NULL),
342 (37, 'no', NULL, NULL),
343 (38, 'system settings', NULL, NULL),
344 (39, 'system_name', NULL, NULL),
345 (40, 'system_title', NULL, NULL),
346 (41, 'slogan', NULL, NULL),
347 (42, 'system_email', NULL, NULL),
348 (43, 'address', NULL, NULL),
349 (44, 'phone', NULL, NULL),
350 (45, 'youtube_api_key', NULL, NULL),
351 (46, 'get_youtube_api_key', NULL, NULL),
352 (47, 'vimeo_api_key', NULL, NULL),
353 (48, 'purchase_code', NULL, NULL),
354 (49, 'language', NULL, NULL),
355 (50, 'text-align', NULL, NULL),
356 (51, 'update_system_settings', NULL, NULL),
357 (52, 'update_product', NULL, NULL),
358 (53, 'file', NULL, NULL),
359 (54, 'install_update', NULL, NULL),
360 (55, 'system_logo', NULL, NULL),
361 (56, 'update_logo', NULL, NULL),
362 (57, 'get_vimeo_api_key', NULL, NULL),
363 (58, 'add_category', NULL, NULL),
364 (59, 'category_title', NULL, NULL),
365 (60, 'sub_categories', NULL, NULL),
366 (61, 'actions', NULL, NULL),
367 (62, 'action', NULL, NULL),
368 (63, 'manage_sub_categories', NULL, NULL),
369 (64, 'edit', NULL, NULL),
370 (65, 'add_course', NULL, NULL),
371 (66, 'select_category', NULL, NULL),
372 (67, 'title', NULL, NULL),
373 (68, 'category', NULL, NULL),
374 (69, '#_section', NULL, NULL),
375 (70, '#_lesson', NULL, NULL),
376 (71, '#_enrolled_user', NULL, NULL),
377 (72, 'view_course_details', NULL, NULL),
378 (73, 'manage_section', NULL, NULL),
379 (74, 'manage_lesson', NULL, NULL),
380 (75, 'student', NULL, NULL),
381 (76, 'add_student', NULL, NULL),
382 (77, 'name', NULL, NULL),
383 (78, 'date_added', NULL, NULL),
384 (79, 'enrolled_courses', NULL, NULL),
385 (80, 'view_profile', NULL, NULL),
386 (81, 'admin_dashboard', NULL, NULL),
387 (82, 'total_courses', NULL, NULL),
388 (83, 'number_of_courses', NULL, NULL),
389 (84, 'total_lessons', NULL, NULL),
390 (85, 'number_of_lessons', NULL, NULL),
391 (86, 'total_enrollment', NULL, NULL),
392 (87, 'number_of_enrollment', NULL, NULL),
393 (88, 'total_student', NULL, NULL),
394 (89, 'number_of_student', NULL, NULL),
395 (90, 'manage_sections', NULL, NULL),
396 (91, 'manage sections', NULL, NULL),
397 (92, 'course', NULL, NULL),
398 (93, 'add_section', NULL, NULL),
399 (94, 'lessons', NULL, NULL),
400 (95, 'serialize_sections', NULL, NULL),
401 (96, 'add_lesson', NULL, NULL),
402 (97, 'edit_section', NULL, NULL),
403 (98, 'delete_section', NULL, NULL),
404 (99, 'course_details', NULL, NULL),
405 (100, 'course details', NULL, NULL),
406 (101, 'details', NULL, NULL),
407 (102, 'instructor', NULL, NULL),
408 (103, 'sub_category', NULL, NULL),
409 (104, 'enrolled_user', NULL, NULL),
410 (105, 'last_modified', NULL, NULL),
411 (106, 'manage language', NULL, NULL),
412 (107, 'language_list', NULL, NULL),
413 (108, 'add_phrase', NULL, NULL),
414 (109, 'add_language', NULL, NULL),
415 (110, 'option', NULL, NULL),
416 (111, 'edit_phrase', NULL, NULL),
417 (112, 'delete_language', NULL, NULL),
418 (113, 'phrase', NULL, NULL),
419 (114, 'value_required', NULL, NULL),
420 (115, 'frontend settings', NULL, NULL),
421 (116, 'banner_title', NULL, NULL),
422 (117, 'banner_sub_title', NULL, NULL),
423 (118, 'about_us', NULL, NULL),
424 (119, 'blog', NULL, NULL),
425 (120, 'update_frontend_settings', NULL, NULL),
426 (121, 'update_banner', NULL, NULL),
427 (122, 'banner_image', NULL, NULL),
428 (123, 'update_banner_image', NULL, NULL),
429 (124, 'payment settings', NULL, NULL),
430 (125, 'paypal_settings', NULL, NULL),
431 (126, 'client_id', NULL, NULL),
432 (127, 'sandbox', NULL, NULL),
433 (128, 'production', NULL, NULL),
434 (129, 'active', NULL, NULL),
435 (130, 'mode', NULL, NULL),
436 (131, 'stripe_settings', NULL, NULL),
437 (132, 'testmode', NULL, NULL),
438 (133, 'on', NULL, NULL),
439 (134, 'off', NULL, NULL),
440 (135, 'test_secret_key', NULL, NULL),
441 (136, 'test_public_key', NULL, NULL),
442 (137, 'live_secret_key', NULL, NULL),
443 (138, 'live_public_key', NULL, NULL),
444 (139, 'save_changes', NULL, NULL),
445 (141, 'update_phrase', NULL, NULL),
446 (142, 'check', NULL, NULL),
447 (143, 'settings_updated', NULL, NULL),
448 (144, 'checking', NULL, NULL),
449 (145, 'phrase_added', NULL, NULL),
450 (146, 'language_added', NULL, NULL),
451 (147, 'language_deleted', NULL, NULL),
452 (148, 'add course', NULL, NULL),
453 (149, 'add_courses', NULL, NULL),
454 (150, 'add_course_form', NULL, NULL),
455 (151, 'basic_info', NULL, NULL),
456 (152, 'short_description', NULL, NULL),
457 (153, 'description', NULL, NULL),
458 (154, 'level', NULL, NULL),
459 (155, 'beginner', NULL, NULL),
460 (156, 'advanced', NULL, NULL),
461 (157, 'intermediate', NULL, NULL),
462 (158, 'language_made_in', NULL, NULL),
463 (159, 'is_top_course', NULL, NULL),
464 (160, 'outcomes', NULL, NULL),
465 (161, 'category_and_sub_category', NULL, NULL),
466 (162, 'select_a_category', NULL, NULL),
467 (163, 'select_a_category_first', NULL, NULL),
468 (164, 'requirements', NULL, NULL),
469 (165, 'price_and_discount', NULL, NULL),
470 (166, 'price', NULL, NULL),
471 (167, 'has_discount', NULL, NULL),
472 (168, 'discounted_price', NULL, NULL),
473 (169, 'course_thumbnail', NULL, NULL),
474 (170, 'note', NULL, NULL),
475 (171, 'thumbnail_size_should_be_600_x_600', NULL, NULL),
476 (172, 'course_overview_url', NULL, NULL),
477 (173, '0%', NULL, NULL),
478 (174, 'manage profile', NULL, NULL),
479 (175, 'edit_course', NULL, NULL),
480 (176, 'edit course', NULL, NULL),
481 (177, 'edit_courses', NULL, NULL),
482 (178, 'edit_course_form', NULL, NULL),
483 (179, 'update_course', NULL, NULL),
484 (180, 'course_updated', NULL, NULL),
485 (181, 'number_of_sections', NULL, NULL),
486 (182, 'number_of_enrolled_users', NULL, NULL),
487 (183, 'add section', NULL, NULL),
488 (184, 'section', NULL, NULL),
489 (185, 'add_section_form', NULL, NULL),
490 (186, 'update', NULL, NULL),
491 (187, 'serialize_section', NULL, NULL),
492 (188, 'serialize section', NULL, NULL),
493 (189, 'submit', NULL, NULL),
494 (190, 'sections_have_been_serialized', NULL, NULL),
495 (191, 'select_course', NULL, NULL),
496 (192, 'search', NULL, NULL),
497 (193, 'thumbnail', NULL, NULL),
498 (194, 'duration', NULL, NULL),
499 (195, 'provider', NULL, NULL),
500 (196, 'add lesson', NULL, NULL),
501 (197, 'add_lesson_form', NULL, NULL),
502 (198, 'video_type', NULL, NULL),
503 (199, 'select_a_course', NULL, NULL),
504 (200, 'select_a_course_first', NULL, NULL),
505 (201, 'video_url', NULL, NULL),
506 (202, 'invalid_url', NULL, NULL),
507 (203, 'your_video_source_has_to_be_either_youtube_or_vimeo', NULL, NULL),
508 (204, 'for', NULL, NULL),
509 (205, 'of', NULL, NULL),
510 (206, 'edit_lesson', NULL, NULL),
511 (207, 'edit lesson', NULL, NULL),
512 (208, 'edit_lesson_form', NULL, NULL),
513 (209, 'login', NULL, NULL),
514 (210, 'password', NULL, NULL),
515 (211, 'forgot_password', NULL, NULL),
516 (212, 'back_to_website', NULL, NULL),
517 (213, 'send_mail', NULL, NULL),
518 (214, 'back_to_login', NULL, NULL),
519 (215, 'student_add', NULL, NULL),
520 (216, 'student add', NULL, NULL),
521 (217, 'add_students', NULL, NULL),
522 (218, 'student_add_form', NULL, NULL),
523 (219, 'login_credentials', NULL, NULL),
524 (220, 'social_information', NULL, NULL),
525 (221, 'facebook', NULL, NULL),
526 (222, 'twitter', NULL, NULL),
527 (223, 'linkedin', NULL, NULL),
528 (224, 'user_image', NULL, NULL),
529 (225, 'add_user', NULL, NULL),
530 (226, 'user_update_successfully', NULL, NULL),
531 (227, 'user_added_successfully', NULL, NULL),
532 (228, 'student_edit', NULL, NULL),
533 (229, 'student edit', NULL, NULL),
534 (230, 'edit_students', NULL, NULL),
535 (231, 'student_edit_form', NULL, NULL),
536 (232, 'update_user', NULL, NULL),
537 (233, 'enroll history', NULL, NULL),
538 (234, 'filter', NULL, NULL),
539 (235, 'user_name', NULL, NULL),
540 (236, 'enrolled_course', NULL, NULL),
541 (237, 'enrollment_date', NULL, NULL),
542 (238, 'biography2', NULL, NULL),
543 (239, 'home', NULL, NULL),
544 (240, 'search_for_courses', NULL, NULL),
545 (241, 'total', NULL, NULL),
546 (242, 'go_to_cart', NULL, NULL),
547 (243, 'your_cart_is_empty', NULL, NULL),
548 (244, 'log_in', NULL, NULL),
549 (245, 'sign_up', NULL, NULL),
550 (246, 'what_do_you_want_to_learn', NULL, NULL),
551 (247, 'online_courses', NULL, NULL),
552 (248, 'explore_a_variety_of_fresh_topics', NULL, NULL),
553 (249, 'expert_instruction', NULL, NULL),
554 (250, 'find_the_right_course_for_you', NULL, NULL),
555 (251, 'lifetime_access', NULL, NULL),
556 (252, 'learn_on_your_schedule', NULL, NULL),
557 (253, 'top_courses', NULL, NULL),
558 (254, 'last_updater', NULL, NULL),
559 (255, 'hours', NULL, NULL),
560 (256, 'add_to_cart', NULL, NULL),
561 (257, 'top', NULL, NULL),
562 (258, 'latest_courses', NULL, NULL),
563 (259, 'added_to_cart', NULL, NULL),
564 (260, 'admin', NULL, NULL),
565 (261, 'log_in_to_your_udemy_account', NULL, NULL),
566 (262, 'by_signing_up_you_agree_to_our', NULL, NULL),
567 (263, 'terms_of_use', NULL, NULL),
568 (264, 'and', NULL, NULL),
569 (265, 'privacy_policy', NULL, NULL),
570 (266, 'do_not_have_an_account', NULL, NULL),
571 (267, 'sign_up_and_start_learning', NULL, NULL),
572 (268, 'check_here_for_exciting_deals_and_personalized_course_recommendations', NULL, NULL),
573 (269, 'already_have_an_account', NULL, NULL),
574 (270, 'checkout', NULL, NULL),
575 (271, 'paypal', NULL, NULL),
576 (272, 'stripe', NULL, NULL),
577 (273, 'step', NULL, NULL),
578 (274, 'how_would_you_rate_this_course_overall', NULL, NULL),
579 (275, 'write_a_public_review', NULL, NULL),
580 (276, 'describe_your_experience_what_you_got_out_of_the_course_and_other_helpful_highlights', NULL, NULL),
581 (277, 'what_did_the_instructor_do_well_and_what_could_use_some_improvement', NULL, NULL),
582 (278, 'next', NULL, NULL),
583 (279, 'previous', NULL, NULL),
584 (280, 'publish', NULL, NULL),
585 (281, 'search_results', NULL, NULL),
586 (282, 'ratings', NULL, NULL),
587 (283, 'search_results_for', NULL, NULL),
588 (284, 'category_page', NULL, NULL),
589 (285, 'all', NULL, NULL),
590 (286, 'category_list', NULL, NULL),
591 (287, 'by', NULL, NULL),
592 (288, 'go_to_wishlist', NULL, NULL),
593 (289, 'hi', NULL, NULL),
594 (290, 'my_courses', NULL, NULL),
595 (291, 'my_wishlist', NULL, NULL),
596 (292, 'my_messages', NULL, NULL),
597 (293, 'purchase_history', NULL, NULL),
598 (294, 'user_profile', NULL, NULL),
599 (295, 'already_purchased', NULL, NULL),
600 (296, 'all_courses', NULL, NULL),
601 (297, 'wishlists', NULL, NULL),
602 (298, 'search_my_courses', NULL, NULL),
603 (299, 'students_enrolled', NULL, NULL),
604 (300, 'created_by', NULL, NULL),
605 (301, 'last_updated', NULL, NULL),
606 (302, 'what_will_i_learn', NULL, NULL),
607 (303, 'view_more', NULL, NULL),
608 (304, 'other_related_courses', NULL, NULL),
609 (305, 'updated', NULL, NULL),
610 (306, 'curriculum_for_this_course', NULL, NULL),
611 (307, 'about_the_instructor', NULL, NULL),
612 (308, 'reviews', NULL, NULL),
613 (309, 'student_feedback', NULL, NULL),
614 (310, 'average_rating', NULL, NULL),
615 (311, 'preview_this_course', NULL, NULL),
616 (312, 'includes', NULL, NULL),
617 (313, 'on_demand_videos', NULL, NULL),
618 (314, 'full_lifetime_access', NULL, NULL),
619 (315, 'access_on_mobile_and_tv', NULL, NULL),
620 (316, 'course_preview', NULL, NULL),
621 (317, 'instructor_page', NULL, NULL),
622 (318, 'buy_now', NULL, NULL),
623 (319, 'shopping_cart', NULL, NULL),
624 (320, 'courses_in_cart', NULL, NULL),
625 (321, 'student_name', NULL, NULL),
626 (322, 'amount_to_pay', NULL, NULL),
627 (323, 'payment_successfully_done', NULL, NULL),
628 (324, 'filter_by', NULL, NULL),
629 (325, 'instructors', NULL, NULL),
630 (326, 'reset', NULL, NULL),
631 (327, 'your', NULL, NULL),
632 (328, 'rating', NULL, NULL),
633 (329, 'course_detail', NULL, NULL),
634 (330, 'start_lesson', NULL, NULL),
635 (331, 'show_full_biography', NULL, NULL),
636 (332, 'terms_and_condition', NULL, NULL),
637 (333, 'about', NULL, NULL),
638 (334, 'terms_&_condition', NULL, NULL),
639 (335, 'sub categories', NULL, NULL),
640 (336, 'add_sub_category', NULL, NULL),
641 (337, 'sub_category_title', NULL, NULL),
642 (338, 'add sub category', NULL, NULL),
643 (339, 'add_sub_category_form', NULL, NULL),
644 (340, 'sub_category_code', NULL, NULL),
645 (341, 'data_deleted', NULL, NULL),
646 (342, 'edit_category', NULL, NULL),
647 (343, 'edit category', NULL, NULL),
648 (344, 'edit_category_form', NULL, NULL),
649 (345, 'font', NULL, NULL),
650 (346, 'awesome class', NULL, NULL),
651 (347, 'update_category', NULL, NULL),
652 (348, 'data_updated_successfully', NULL, NULL),
653 (349, 'edit_sub_category', NULL, NULL),
654 (350, 'edit sub category', NULL, NULL),
655 (351, 'sub_category_edit', NULL, NULL),
656 (352, 'update_sub_category', NULL, NULL),
657 (353, 'course_added', NULL, NULL),
658 (354, 'user_deleted_successfully', NULL, NULL),
659 (355, 'private_messaging', NULL, NULL),
660 (356, 'private messaging', NULL, NULL),
661 (357, 'messages', NULL, NULL),
662 (358, 'select_message_to_read', NULL, NULL),
663 (359, 'new_message', NULL, NULL),
664 (360, 'email_duplication', NULL, NULL),
665 (361, 'your_registration_has_been_successfully_done', NULL, NULL),
666 (362, 'profile', NULL, NULL),
667 (363, 'account', NULL, NULL),
668 (364, 'add_information_about_yourself_to_share_on_your_profile', NULL, NULL),
669 (365, 'basics', NULL, NULL),
670 (366, 'add_your_twitter_link', NULL, NULL),
671 (367, 'add_your_facebook_link', NULL, NULL),
672 (368, 'add_your_linkedin_link', NULL, NULL),
673 (369, 'credentials', NULL, NULL),
674 (370, 'edit_your_account_settings', NULL, NULL),
675 (371, 'enter_current_password', NULL, NULL),
676 (372, 'enter_new_password', NULL, NULL),
677 (373, 're-type_your_password', NULL, NULL),
678 (374, 'save', NULL, NULL),
679 (375, 'update_user_photo', NULL, NULL),
680 (376, 'update_your_photo', NULL, NULL),
681 (377, 'upload_image', NULL, NULL),
682 (378, 'updated_successfully', NULL, NULL),
683 (379, 'invalid_login_credentials', NULL, NULL),
684 (380, 'blank_page', NULL, NULL),
685 (381, 'no_section_found', NULL, NULL),
686 (382, 'select_a_message_thread_to_read_it_here', NULL, NULL),
687 (383, 'send', NULL, NULL),
688 (384, 'type_your_message', NULL, NULL),
689 (385, 'date', NULL, NULL),
690 (386, 'total_price', NULL, NULL),
691 (387, 'payment_type', NULL, NULL),
692 (388, 'edit section', NULL, NULL),
693 (389, 'edit_section_form', NULL, NULL),
694 (390, 'reply_message', NULL, NULL),
695 (391, 'reply', NULL, NULL),
696 (392, 'log_in_to_your_account', NULL, NULL),
697 (393, 'no_result_found', NULL, NULL),
698 (394, 'enrollment', NULL, NULL),
699 (395, 'enroll_a_student', NULL, NULL),
700 (396, 'report', NULL, NULL),
701 (397, 'admin_revenue', NULL, NULL),
702 (398, 'instructor_revenue', NULL, NULL),
703 (399, 'instructor_settings', NULL, NULL),
704 (400, 'view_frontend', NULL, NULL),
705 (401, 'number_of_active_courses', NULL, NULL),
706 (402, 'number_of_pending_courses', NULL, NULL),
707 (403, 'all_instructor', NULL, NULL),
708 (404, 'active_courses', NULL, NULL),
709 (405, 'pending_courses', NULL, NULL),
710 (406, 'no_data_found', NULL, NULL),
711 (407, 'view_course_on_frontend', NULL, NULL),
712 (408, 'mark_as_pending', NULL, NULL),
713 (409, 'add category', NULL, NULL),
714 (410, 'add_categories', NULL, NULL),
715 (411, 'category_add_form', NULL, NULL),
716 (412, 'icon_picker', NULL, NULL),
717 (413, 'enroll a student', NULL, NULL),
718 (414, 'enrollment_form', NULL, NULL),
719 (415, 'admin revenue', NULL, NULL),
720 (416, 'total_amount', NULL, NULL),
721 (417, 'instructor revenue', NULL, NULL),
722 (418, 'status', NULL, NULL),
723 (419, 'instructor settings', NULL, NULL),
724 (420, 'allow_public_instructor', NULL, NULL),
725 (421, 'instructor_revenue_percentage', NULL, NULL),
726 (422, 'admin_revenue_percentage', NULL, NULL),
727 (423, 'update_instructor_settings', NULL, NULL),
728 (424, 'payment_info', NULL, NULL),
729 (425, 'required_for_instructors', NULL, NULL),
730 (426, 'paypal_client_id', NULL, NULL),
731 (427, 'stripe_public_key', NULL, NULL),
732 (428, 'stripe_secret_key', NULL, NULL),
733 (429, 'mark_as_active', NULL, NULL),
734 (430, 'mail_subject', NULL, NULL),
735 (431, 'mail_body', NULL, NULL),
736 (432, 'paid', NULL, NULL),
737 (433, 'pending', NULL, NULL),
738 (434, 'this_instructor_has_not_provided_valid_paypal_client_id', NULL, NULL),
739 (435, 'pay_with_paypal', NULL, NULL),
740 (436, 'this_instructor_has_not_provided_valid_public_key_or_secret_key', NULL, NULL),
741 (437, 'pay_with_stripe', NULL, NULL),
742 (438, 'create_course', NULL, NULL),
743 (439, 'payment_report', NULL, NULL),
744 (440, 'instructor_dashboard', NULL, NULL),
745 (441, 'draft', NULL, NULL),
746 (442, 'view_lessons', NULL, NULL),
747 (443, 'course_title', NULL, NULL),
748 (444, 'update_your_payment_settings', NULL, NULL),
749 (445, 'edit_course_detail', NULL, NULL),
750 (446, 'edit_basic_informations', NULL, NULL),
751 (447, 'publish_this_course', NULL, NULL),
752 (448, 'save_to_draft', NULL, NULL),
753 (449, 'update_section', NULL, NULL),
754 (450, 'analyzing_given_url', NULL, NULL),
755 (451, 'select_a_section', NULL, NULL),
756 (452, 'update_lesson', NULL, NULL),
757 (453, 'website_name', NULL, NULL),
758 (454, 'website_title', NULL, NULL),
759 (455, 'website_keywords', NULL, NULL),
760 (456, 'website_description', NULL, NULL),
761 (457, 'author', NULL, NULL),
762 (458, 'footer_text', NULL, NULL),
763 (459, 'footer_link', NULL, NULL),
764 (460, 'update_backend_logo', NULL, NULL),
765 (461, 'update_favicon', NULL, NULL),
766 (462, 'favicon', NULL, NULL),
767 (463, 'active courses', NULL, NULL),
768 (464, 'product_updated_successfully', NULL, NULL),
769 (465, 'course_overview_provider', NULL, NULL),
770 (466, 'youtube', NULL, NULL),
771 (467, 'vimeo', NULL, NULL),
772 (468, 'html5', NULL, NULL),
773 (469, 'meta_keywords', NULL, NULL),
774 (470, 'meta_description', NULL, NULL),
775 (471, 'lesson_type', NULL, NULL),
776 (472, 'video', NULL, NULL),
777 (473, 'select_type_of_lesson', NULL, NULL),
778 (474, 'text_file', NULL, NULL),
779 (475, 'pdf_file', NULL, NULL),
780 (476, 'document_file', NULL, NULL),
781 (477, 'image_file', NULL, NULL),
782 (478, 'lesson_provider', NULL, NULL),
783 (479, 'select_lesson_provider', NULL, NULL),
784 (480, 'analyzing_the_url', NULL, NULL),
785 (481, 'attachment', NULL, NULL),
786 (482, 'summary', NULL, NULL),
787 (483, 'download', NULL, NULL),
788 (484, 'system_settings_updated', NULL, NULL),
789 (485, 'course_updated_successfully', NULL, NULL),
790 (486, 'please_wait_untill_admin_approves_it', NULL, NULL),
791 (487, 'pending courses', NULL, NULL),
792 (488, 'course_status_updated', NULL, NULL),
793 (489, 'smtp_settings', NULL, NULL),
794 (490, 'free_course', NULL, NULL),
795 (491, 'free', NULL, NULL),
796 (492, 'get_enrolled', NULL, NULL),
797 (493, 'course_added_successfully', NULL, NULL),
798 (494, 'update_frontend_logo', NULL, NULL),
799 (495, 'system_currency_settings', NULL, NULL),
800 (496, 'select_system_currency', NULL, NULL),
801 (497, 'currency_position', NULL, NULL),
802 (498, 'left', NULL, NULL),
803 (499, 'right', NULL, NULL),
804 (500, 'left_with_a_space', NULL, NULL),
805 (501, 'right_with_a_space', NULL, NULL),
806 (502, 'paypal_currency', NULL, NULL),
807 (503, 'select_paypal_currency', NULL, NULL),
808 (504, 'stripe_currency', NULL, NULL),
809 (505, 'select_stripe_currency', NULL, NULL),
810 (506, 'heads_up', NULL, NULL),
811 (507, 'please_make_sure_that', NULL, NULL),
812 (508, 'system_currency', NULL, NULL),
813 (509, 'are_same', NULL, NULL),
814 (510, 'smtp settings', NULL, NULL),
815 (511, 'protocol', NULL, NULL),
816 (512, 'smtp_host', NULL, NULL),
817 (513, 'smtp_port', NULL, NULL),
818 (514, 'smtp_user', NULL, NULL),
819 (515, 'smtp_pass', NULL, NULL),
820 (516, 'update_smtp_settings', NULL, NULL),
821 (517, 'phrase_updated', NULL, NULL),
822 (518, 'registered_user', NULL, NULL),
823 (519, 'provide_your_valid_login_credentials', NULL, NULL),
824 (520, 'registration_form', NULL, NULL),
825 (521, 'provide_your_email_address_to_get_password', NULL, NULL),
826 (522, 'reset_password', NULL, NULL),
827 (523, 'want_to_go_back', NULL, NULL),
828 (524, 'message_sent!', NULL, NULL),
829 (525, 'selected_icon', NULL, NULL),
830 (526, 'pick_another_icon_picker', NULL, NULL),
831 (527, 'show_more', NULL, NULL),
832 (528, 'show_less', NULL, NULL),
833 (529, 'all_category', NULL, NULL),
834 (530, 'price_range', NULL, NULL),
835 (531, 'price_range_withing', NULL, NULL),
836 (532, 'all_categories', NULL, NULL),
837 (533, 'all_sub_category', NULL, NULL),
838 (534, 'number_of_results', NULL, NULL),
839 (535, 'showing_on_this_page', NULL, NULL),
840 (536, 'welcome', NULL, NULL),
841 (537, 'my_account', NULL, NULL),
842 (538, 'logout', NULL, NULL),
843 (539, 'visit_website', NULL, NULL),
844 (540, 'navigation', NULL, NULL),
845 (541, 'add_new_category', NULL, NULL),
846 (542, 'enrolment', NULL, NULL),
847 (543, 'enrol_history', NULL, NULL),
848 (544, 'enrol_a_student', NULL, NULL),
849 (545, 'language_settings', NULL, NULL),
850 (546, 'congratulations', NULL, NULL),
851 (547, 'oh_snap', NULL, NULL),
852 (548, 'close', NULL, NULL),
853 (549, 'parent', NULL, NULL),
854 (550, 'none', NULL, NULL),
855 (551, 'category_thumbnail', NULL, NULL),
856 (552, 'the_image_size_should_be', NULL, NULL),
857 (553, 'choose_thumbnail', NULL, NULL),
858 (554, 'data_added_successfully', NULL, NULL),
859 (555, '', NULL, NULL),
860 (556, 'update_category_form', NULL, NULL),
861 (557, 'student_list', NULL, NULL),
862 (558, 'choose_user_image', NULL, NULL),
863 (559, 'finish', NULL, NULL),
864 (560, 'thank_you', NULL, NULL),
865 (561, 'you_are_almost_there', NULL, NULL),
866 (562, 'you_are_just_one_click_away', NULL, NULL),
867 (563, 'country', NULL, NULL),
868 (564, 'website_settings', NULL, NULL),
869 (565, 'write_down_facebook_url', NULL, NULL),
870 (566, 'write_down_twitter_url', NULL, NULL),
871 (567, 'write_down_linkedin_url', NULL, NULL),
872 (568, 'google_link', NULL, NULL),
873 (569, 'write_down_google_url', NULL, NULL),
874 (570, 'instagram_link', NULL, NULL),
875 (571, 'write_down_instagram_url', NULL, NULL),
876 (572, 'pinterest_link', NULL, NULL),
877 (573, 'write_down_pinterest_url', NULL, NULL),
878 (574, 'update_settings', NULL, NULL),
879 (575, 'upload_banner_image', NULL, NULL),
880 (576, 'update_light_logo', NULL, NULL),
881 (577, 'upload_light_logo', NULL, NULL),
882 (578, 'update_dark_logo', NULL, NULL),
883 (579, 'upload_dark_logo', NULL, NULL),
884 (580, 'update_small_logo', NULL, NULL),
885 (581, 'upload_small_logo', NULL, NULL),
886 (582, 'upload_favicon', NULL, NULL),
887 (583, 'logo_updated', NULL, NULL),
888 (584, 'favicon_updated', NULL, NULL),
889 (585, 'banner_image_update', NULL, NULL),
890 (586, 'frontend_settings_updated', NULL, NULL),
891 (587, 'setup_payment_informations', NULL, NULL),
892 (588, 'update_system_currency', NULL, NULL),
893 (589, 'setup_paypal_settings', NULL, NULL),
894 (590, 'update_paypal_keys', NULL, NULL),
895 (591, 'setup_stripe_settings', NULL, NULL),
896 (592, 'test_mode', NULL, NULL),
897 (593, 'update_stripe_keys', NULL, NULL);
898
899 -- --------------------------------------------------------
900
901 --
902 -- Table structure for table `lesson`
903 --
904
905 CREATE TABLE `lesson` (
906 `id` int(11) UNSIGNED NOT NULL,
907 `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
908 `duration` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
909 `course_id` int(11) DEFAULT NULL,
910 `section_id` int(11) DEFAULT NULL,
911 `video_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
912 `video_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
913 `date_added` int(11) DEFAULT NULL,
914 `last_modified` int(11) DEFAULT NULL,
915 `lesson_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
916 `attachment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
917 `attachment_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
918 `summary` longtext COLLATE utf8_unicode_ci,
919 `order` int(11) NOT NULL DEFAULT '0'
920 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
921
922 -- --------------------------------------------------------
923
924 --
925 -- Table structure for table `message`
926 --
927
928 CREATE TABLE `message` (
929 `message_id` int(11) NOT NULL,
930 `message_thread_code` longtext,
931 `message` longtext,
932 `sender` longtext,
933 `timestamp` longtext,
934 `read_status` int(11) DEFAULT NULL
935 ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
936
937 -- --------------------------------------------------------
938
939 --
940 -- Table structure for table `message_thread`
941 --
942
943 CREATE TABLE `message_thread` (
944 `message_thread_id` int(11) NOT NULL,
945 `message_thread_code` longtext COLLATE utf8_unicode_ci,
946 `sender` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
947 `receiver` varchar(255) COLLATE utf8_unicode_ci DEFAULT '',
948 `last_message_timestamp` longtext COLLATE utf8_unicode_ci
949 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
950
951 -- --------------------------------------------------------
952
953 --
954 -- Table structure for table `payment`
955 --
956
957 CREATE TABLE `payment` (
958 `id` int(11) UNSIGNED NOT NULL,
959 `user_id` int(11) DEFAULT NULL,
960 `payment_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
961 `course_id` int(11) DEFAULT NULL,
962 `amount` double DEFAULT NULL,
963 `date_added` int(11) DEFAULT NULL,
964 `last_modified` int(11) DEFAULT NULL,
965 `admin_revenue` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
966 `instructor_revenue` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
967 `instructor_payment_status` int(11) DEFAULT '0'
968 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
969
970 -- --------------------------------------------------------
971
972 --
973 -- Table structure for table `question`
974 --
975
976 CREATE TABLE `question` (
977 `id` int(11) UNSIGNED NOT NULL,
978 `quiz_id` int(11) DEFAULT NULL,
979 `title` longtext COLLATE utf8_unicode_ci,
980 `type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
981 `number_of_options` int(11) DEFAULT NULL,
982 `options` longtext COLLATE utf8_unicode_ci,
983 `correct_answers` longtext COLLATE utf8_unicode_ci,
984 `order` int(11) NOT NULL DEFAULT '0'
985 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
986
987 -- --------------------------------------------------------
988
989 --
990 -- Table structure for table `rating`
991 --
992
993 CREATE TABLE `rating` (
994 `id` int(11) UNSIGNED NOT NULL,
995 `rating` double DEFAULT NULL,
996 `user_id` int(11) DEFAULT NULL,
997 `ratable_id` int(11) DEFAULT NULL,
998 `ratable_type` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
999 `date_added` int(11) DEFAULT NULL,
1000 `last_modified` int(11) DEFAULT NULL,
1001 `review` longtext COLLATE utf8_unicode_ci
1002 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1003
1004 -- --------------------------------------------------------
1005
1006 --
1007 -- Table structure for table `role`
1008 --
1009
1010 CREATE TABLE `role` (
1011 `id` int(11) UNSIGNED NOT NULL,
1012 `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1013 `date_added` int(11) DEFAULT NULL,
1014 `last_modified` int(11) DEFAULT NULL
1015 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1016
1017 --
1018 -- Dumping data for table `role`
1019 --
1020
1021 INSERT INTO `role` (`id`, `name`, `date_added`, `last_modified`) VALUES
1022 (1, 'Admin', 1234567890, 1234567890),
1023 (2, 'User', 1234567890, 1234567890);
1024
1025 -- --------------------------------------------------------
1026
1027 --
1028 -- Table structure for table `section`
1029 --
1030
1031 CREATE TABLE `section` (
1032 `id` int(11) NOT NULL,
1033 `title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1034 `course_id` int(11) DEFAULT NULL,
1035 `order` int(11) NOT NULL DEFAULT '0'
1036 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1037
1038 -- --------------------------------------------------------
1039
1040 --
1041 -- Table structure for table `settings`
1042 --
1043
1044 CREATE TABLE `settings` (
1045 `id` int(11) UNSIGNED NOT NULL,
1046 `key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1047 `value` longtext COLLATE utf8_unicode_ci
1048 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1049
1050 --
1051 -- Dumping data for table `settings`
1052 --
1053
1054 INSERT INTO `settings` (`id`, `key`, `value`) VALUES
1055 (1, 'language', 'english'),
1056 (2, 'system_name', 'Learning Management System Online'),
1057 (3, 'system_title', 'Learning Management System Online'),
1058 (4, 'system_email', 'admin@example.com'),
1059 (5, 'address', 'Learning Management System Online'),
1060 (6, 'phone', '+143-52-9933631'),
1061 (7, 'purchase_code', 'your-purchase-code'),
1062 (8, 'paypal', '[{\"active\":\"1\",\"mode\":\"sandbox\",\"sandbox_client_id\":\"AZDxjDScFpQtjWTOUtWKbyN_bDt4OgqaF4eYXlewfBP4-8aqX3PiV8e1GWU6liB2CUXlkA59kJXE7M6R\",\"production_client_id\":\"1234\"}]'),
1063 (9, 'stripe_keys', '[{\"active\":\"1\",\"testmode\":\"on\",\"public_key\":\"pk_test_c6VvBEbwHFdulFZ62q1IQrar\",\"secret_key\":\"sk_test_9IMkiM6Ykxr1LCe2dJ3PgaxS\",\"public_live_key\":\"pk_live_xxxxxxxxxxxxxxxxxxxxxxxx\",\"secret_live_key\":\"sk_live_xxxxxxxxxxxxxxxxxxxxxxxx\"}]'),
1064 (10, 'youtube_api_key', 'AIzaSyBBJrcS7AhGd1Cgd6GKH3G5aUUj9L9NrFQ'),
1065 (11, 'vimeo_api_key', '39258384b69994dba483c10286825b5c'),
1066 (12, 'slogan', 'A course based video CMS'),
1067 (13, 'text_align', NULL),
1068 (14, 'allow_instructor', '1'),
1069 (15, 'instructor_revenue', '64'),
1070 (16, 'system_currency', 'USD'),
1071 (17, 'paypal_currency', 'USD'),
1072 (18, 'stripe_currency', 'USD'),
1073 (19, 'author', 'Learning Management System Online'),
1074 (20, 'currency_position', 'left'),
1075 (21, 'website_description', 'Nice application'),
1076 (22, 'website_keywords', 'LMS,Learning Management System,Creativeitem,demo,hello,How are you'),
1077 (23, 'footer_text', NULL),
1078 (24, 'footer_link', 'http://lms.com/'),
1079 (25, 'protocol', 'smtp'),
1080 (26, 'smtp_host', 'ssl://smtp.googlemail.com'),
1081 (27, 'smtp_port', '465'),
1082 (28, 'smtp_user', ''),
1083 (29, 'smtp_pass', ''),
1084 (30, 'version', '2.0.1'),
1085 (31, 'student_email_verification', 'disable');
1086
1087 -- --------------------------------------------------------
1088
1089 --
1090 -- Table structure for table `tag`
1091 --
1092
1093 CREATE TABLE `tag` (
1094 `id` int(11) UNSIGNED NOT NULL,
1095 `tag` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1096 `tagable_id` int(11) DEFAULT NULL,
1097 `tagable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1098 `date_added` int(11) DEFAULT NULL,
1099 `last_modified` int(11) DEFAULT NULL
1100 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1101
1102 -- --------------------------------------------------------
1103
1104 --
1105 -- Table structure for table `users`
1106 --
1107
1108 CREATE TABLE `users` (
1109 `id` int(11) UNSIGNED NOT NULL,
1110 `first_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1111 `last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1112 `email` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
1113 `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
1114 `social_links` longtext COLLATE utf8_unicode_ci,
1115 `biography` longtext COLLATE utf8_unicode_ci,
1116 `role_id` int(11) DEFAULT NULL,
1117 `date_added` int(11) DEFAULT NULL,
1118 `last_modified` int(11) DEFAULT NULL,
1119 `watch_history` longtext COLLATE utf8_unicode_ci,
1120 `wishlist` longtext COLLATE utf8_unicode_ci,
1121 `title` longtext COLLATE utf8_unicode_ci,
1122 `paypal_keys` longtext COLLATE utf8_unicode_ci,
1123 `stripe_keys` longtext COLLATE utf8_unicode_ci,
1124 `verification_code` longtext COLLATE utf8_unicode_ci,
1125 `status` int(11) DEFAULT NULL
1126 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
1127
1128 --
1129 -- Dumping data for table `users`
1130 --
1131
1132 INSERT INTO `users` (`id`, `first_name`, `last_name`, `email`, `password`, `social_links`, `biography`, `role_id`, `date_added`, `last_modified`, `watch_history`, `wishlist`, `title`, `paypal_keys`, `stripe_keys`, `verification_code`, `status`) VALUES
1133 (1, 'admin', 'admin', 'admin@example.com', 'd033e22ae348aeb5660fc2140aec35850c4da997', '{\"facebook\":\"\",\"twitter\":\"\",\"linkedin\":\"\"}', NULL, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1);
1134
1135 --
1136 -- Indexes for dumped tables
1137 --
1138
1139 --
1140 -- Indexes for table `category`
1141 --
1142 ALTER TABLE `category`
1143 ADD PRIMARY KEY (`id`);
1144
1145 --
1146 -- Indexes for table `comment`
1147 --
1148 ALTER TABLE `comment`
1149 ADD PRIMARY KEY (`id`);
1150
1151 --
1152 -- Indexes for table `course`
1153 --
1154 ALTER TABLE `course`
1155 ADD PRIMARY KEY (`id`);
1156
1157 --
1158 -- Indexes for table `currency`
1159 --
1160 ALTER TABLE `currency`
1161 ADD PRIMARY KEY (`id`);
1162
1163 --
1164 -- Indexes for table `enrol`
1165 --
1166 ALTER TABLE `enrol`
1167 ADD PRIMARY KEY (`id`);
1168
1169 --
1170 -- Indexes for table `frontend_settings`
1171 --
1172 ALTER TABLE `frontend_settings`
1173 ADD PRIMARY KEY (`id`);
1174
1175 --
1176 -- Indexes for table `language`
1177 --
1178 ALTER TABLE `language`
1179 ADD PRIMARY KEY (`phrase_id`);
1180
1181 --
1182 -- Indexes for table `lesson`
1183 --
1184 ALTER TABLE `lesson`
1185 ADD PRIMARY KEY (`id`);
1186
1187 --
1188 -- Indexes for table `message`
1189 --
1190 ALTER TABLE `message`
1191 ADD PRIMARY KEY (`message_id`);
1192
1193 --
1194 -- Indexes for table `message_thread`
1195 --
1196 ALTER TABLE `message_thread`
1197 ADD PRIMARY KEY (`message_thread_id`);
1198
1199 --
1200 -- Indexes for table `payment`
1201 --
1202 ALTER TABLE `payment`
1203 ADD PRIMARY KEY (`id`);
1204
1205 --
1206 -- Indexes for table `question`
1207 --
1208 ALTER TABLE `question`
1209 ADD PRIMARY KEY (`id`);
1210
1211 --
1212 -- Indexes for table `rating`
1213 --
1214 ALTER TABLE `rating`
1215 ADD PRIMARY KEY (`id`);
1216
1217 --
1218 -- Indexes for table `role`
1219 --
1220 ALTER TABLE `role`
1221 ADD PRIMARY KEY (`id`);
1222
1223 --
1224 -- Indexes for table `section`
1225 --
1226 ALTER TABLE `section`
1227 ADD PRIMARY KEY (`id`);
1228
1229 --
1230 -- Indexes for table `settings`
1231 --
1232 ALTER TABLE `settings`
1233 ADD PRIMARY KEY (`id`);
1234
1235 --
1236 -- Indexes for table `tag`
1237 --
1238 ALTER TABLE `tag`
1239 ADD PRIMARY KEY (`id`);
1240
1241 --
1242 -- Indexes for table `users`
1243 --
1244 ALTER TABLE `users`
1245 ADD PRIMARY KEY (`id`);
1246
1247 --
1248 -- AUTO_INCREMENT for dumped tables
1249 --
1250
1251 --
1252 -- AUTO_INCREMENT for table `category`
1253 --
1254 ALTER TABLE `category`
1255 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1256
1257 --
1258 -- AUTO_INCREMENT for table `comment`
1259 --
1260 ALTER TABLE `comment`
1261 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1262
1263 --
1264 -- AUTO_INCREMENT for table `course`
1265 --
1266 ALTER TABLE `course`
1267 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1268
1269 --
1270 -- AUTO_INCREMENT for table `currency`
1271 --
1272 ALTER TABLE `currency`
1273 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=113;
1274
1275 --
1276 -- AUTO_INCREMENT for table `enrol`
1277 --
1278 ALTER TABLE `enrol`
1279 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1280
1281 --
1282 -- AUTO_INCREMENT for table `frontend_settings`
1283 --
1284 ALTER TABLE `frontend_settings`
1285 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
1286
1287 --
1288 -- AUTO_INCREMENT for table `language`
1289 --
1290 ALTER TABLE `language`
1291 MODIFY `phrase_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=594;
1292
1293 --
1294 -- AUTO_INCREMENT for table `lesson`
1295 --
1296 ALTER TABLE `lesson`
1297 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1298
1299 --
1300 -- AUTO_INCREMENT for table `message`
1301 --
1302 ALTER TABLE `message`
1303 MODIFY `message_id` int(11) NOT NULL AUTO_INCREMENT;
1304
1305 --
1306 -- AUTO_INCREMENT for table `message_thread`
1307 --
1308 ALTER TABLE `message_thread`
1309 MODIFY `message_thread_id` int(11) NOT NULL AUTO_INCREMENT;
1310
1311 --
1312 -- AUTO_INCREMENT for table `payment`
1313 --
1314 ALTER TABLE `payment`
1315 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1316
1317 --
1318 -- AUTO_INCREMENT for table `question`
1319 --
1320 ALTER TABLE `question`
1321 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1322
1323 --
1324 -- AUTO_INCREMENT for table `rating`
1325 --
1326 ALTER TABLE `rating`
1327 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1328
1329 --
1330 -- AUTO_INCREMENT for table `role`
1331 --
1332 ALTER TABLE `role`
1333 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
1334
1335 --
1336 -- AUTO_INCREMENT for table `section`
1337 --
1338 ALTER TABLE `section`
1339 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1340
1341 --
1342 -- AUTO_INCREMENT for table `settings`
1343 --
1344 ALTER TABLE `settings`
1345 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;
1346
1347 --
1348 -- AUTO_INCREMENT for table `tag`
1349 --
1350 ALTER TABLE `tag`
1351 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1352
1353 --
1354 -- AUTO_INCREMENT for table `users`
1355 --
1356 ALTER TABLE `users`
1357 MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
1358 COMMIT;
1359
1360 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1361 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1362 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;